package org.penguin.study.bk.dao

import com.baomidou.mybatisplus.core.mapper.BaseMapper
import org.apache.ibatis.annotations.*
import org.penguin.study.bk.entity.Message
import java.util.*

@Mapper
interface MessageMapper : BaseMapper<Message> {

    @Select("SELECT * FROM tbl_messages WHERE text = #{text}")
    fun queryByText(@Param("text") text: String): List<Message>

    @Select("select now()")
    fun now(): Date
}